Explore Plans
Mobile menu Close menu
Google SheetsGoogle Sheets

Current value of a cell

This query returns the current value of a single cell in your spreadsheet.

Developer info

API endpoint slug
google_sheets.cell_value
Runtime method
performQuery("google_sheets.cell_value")

Query fields

Cell Text input > Other

Label
Which cell?
Helper text
E.g. C25, Sheet2!B5, or 'Monthly budget'!B12 (must be a valid single cell)
Slug
cell
Required
true
Can have default value
true

Spreadsheet URL Text input

Label
Copy and paste the spreadsheet URL
Helper text
Must be a valid Google Sheets spreadsheet URL
Slug
spreadsheet_url
Required
true
Can have default value
true

Ingredients

ValueThe current value of the cell.

Slug
value
Filter code
GoogleSheets.cellValue.Value
Type
String
Example
$120.00

CellThe address of the cell.

Slug
cell
Filter code
GoogleSheets.cellValue.Cell
Type
String
Example
A20

Spreadsheet nameThe title of the spreadsheet.

Slug
spreadsheet_name
Filter code
GoogleSheets.cellValue.SpreadsheetName
Type
String
Example
Monthly family budget

Spreadsheet URLThe URL of the spreadsheet.

Slug
spreadsheet_url
Filter code
GoogleSheets.cellValue.SpreadsheetUrl
Type
String
Example
https://docs.google.com/spreadsheets/d/XXXXXXXXX/edit#gid=0

Checked atThe timestamp when the value of the cell was fetched.

Slug
checked_at
Filter code
GoogleSheets.cellValue.CheckedAt
Type
Date with time (ISO8601)
Example
2020-07-08T04:17:06.000+05:00